<%@page import="tx.bjdacp.model.*" %>
<%@ page contentType="application/msexcel;charset=UTF-8" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib tagdir="/WEB-INF/tags/simpletable" prefix="simpletable"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
<%@ taglib uri="/struts-tags" prefix="s" %>
<%@ taglib uri="http://www.springframework.org/security/tags" prefix="sec"%>

<%@ taglib uri="http://www.rapid-framework.org.cn/rapid" prefix="rapid" %>
<%
   response.setHeader("Content-disposition","attachment; filename=data.xls");
%>


		<table width="100%"  border="1" cellspacing="0">


			  <tr>
			  	<td sortColumn="file_number" ><%=DrugSellUnit.ALIAS_FILE_NUMBER%></th>
				<td sortColumn="zone_id" >所在镇</td>
				<td sortColumn="unit_name" ><%=DrugSellUnit.ALIAS_UNIT_NAME%></td>
				<td sortColumn="regist_address" ><%=DrugSellUnit.ALIAS_REGIST_ADDRESS%></td>
				<td sortColumn="artificial_person" ><%=DrugSellUnit.ALIAS_ARTIFICIAL_PERSON%></td>
				<td sortColumn="unit_principal" ><%=DrugSellUnit.ALIAS_UNIT_PRINCIPAL%></td>
				<td sortColumn="quality_principal" ><%=DrugSellUnit.ALIAS_QUALITY_PRINCIPAL%></td>
				<td sortColumn="apothecary" ><%=DrugSellUnit.ALIAS_APOTHECARY%></td>
				<td sortColumn="apothecary2" ><%=DrugSellUnit.ALIAS_APOTHECARY2%></td>
				<td sortColumn="apothecaryChina" ><%=DrugSellUnit.ALIAS_APOTHECARY_CHINA%></td>
				<td sortColumn="sell_mode" ><%=DrugSellUnit.ALIAS_SELL_MODE%></td>
				<td sortColumn="sell_area" ><%=DrugSellUnit.ALIAS_SELL_AREA%></td>
				<td sortColumn="storage_address" ><%=DrugSellUnit.ALIAS_STORAGE_ADDRESS%></td>
				<td sortColumn="licence_code" ><%=DrugSellUnit.ALIAS_LICENCE_CODE%></td>
				<td sortColumn="unit_found_date" ><%=DrugSellUnit.ALIAS_UNIT_FOUND_DATE%></td>
				<td sortColumn="licence_give_date" ><%=DrugSellUnit.ALIAS_LICENCE_GIVE_DATE%></td>
				<td sortColumn="licence_expiry_date" ><%=DrugSellUnit.ALIAS_LICENCE_EXPIRY_DATE%></td>
				<td sortColumn="gsp_code" ><%=DrugSellUnit.ALIAS_GSP_CODE%></td>
				<td sortColumn="gsp_give_date" ><%=DrugSellUnit.ALIAS_GSP_GIVE_DATE%></td>
				<td sortColumn="gsp_expiry_date" ><%=DrugSellUnit.ALIAS_GSP_EXPIRY_DATE%></td>
				<td sortColumn="is_logout" ><%=DrugSellUnit.ALIAS_IS_LOGOUT%></td>
				<td sortColumn="logout_date" ><%=DrugSellUnit.ALIAS_LOGOUT_DATE%></td>
				<td sortColumn="mobel_phone" ><%=DrugSellUnit.ALIAS_MOBEL_PHONE%></td>
				<td sortColumn="phone" ><%=DrugSellUnit.ALIAS_PHONE%></td>
				<td sortColumn="is_tour_drugstore" ><%=DrugSellUnit.ALIAS_IS_TOUR_DRUGSTORE%></td>
				<td sortColumn="is_sell_chinese_medicine" ><%=DrugSellUnit.ALIAS_IS_SELL_CHINESE_MEDICINE%></td>
				<td sortColumn="is_OTC_unit" ><%=DrugSellUnit.ALIAS_IS_OTCUNIT%></td>
				<td sortColumn="is_resend_license" ><%=DrugSellUnit.ALIAS_IS_RESEND_LICENSE%></td>


			  </tr>


		  <tbody>
		  	  <c:forEach items="${page.result}" var="item" varStatus="status">

			  <tr >
			  	<td><c:out value='${item.fileNumber}'/>&nbsp;</td>
				<td><c:out value='${item.zone.zoneName}'/>&nbsp;</td>
				<td><c:out value='${item.unitName}'/>&nbsp;</td>
				<td><c:out value='${item.registAddress}'/>&nbsp;</td>
				<td><c:out value='${item.artificialPerson}'/>&nbsp;</td>
				<td><c:out value='${item.unitPrincipal}'/>&nbsp;</td>
				<td><c:out value='${item.qualityPrincipal}'/>&nbsp;</td>
				<td><c:out value='${item.apothecary}'/>&nbsp;</td>
				<td><c:out value='${item.apothecary2}'/>&nbsp;</td>
				<td><c:out value='${item.apothecaryChina}'/>&nbsp;</td>
				<td><c:out value='${item.sellMode}'/>&nbsp;</td>
				<td><c:out value='${item.sellArea}'/>&nbsp;</td>
				<td><c:out value='${item.storageAddress}'/>&nbsp;</td>
				<td><c:out value='${item.licenceCode}'/>&nbsp;</td>
				<td><c:out value='${item.unitFoundDateString}'/>&nbsp;</td>
				<td><c:out value='${item.licenceGiveDateString}'/>&nbsp;</td>
				<td><c:out value='${item.licenceExpiryDateString}'/>&nbsp;</td>
				<td><c:out value='${item.gspCode}'/>&nbsp;</td>
				<td><c:out value='${item.gspGiveDateString}'/>&nbsp;</td>
				<td><c:out value='${item.gspExpiryDateString}'/>&nbsp;</td>
				<td><c:out value='${item.isLogout}'/>&nbsp;</td>
				<td><c:out value='${item.logoutDate}'/>&nbsp;</td>
				<td><c:out value='${item.mobelPhone}'/>&nbsp;</td>
				<td><c:out value='${item.phone}'/>&nbsp;</td>
				<td><c:out value='${item.isTourDrugstoreString}'/>&nbsp;</td>
				<td><c:out value='${item.isSellChineseMedicineString}'/>&nbsp;</td>
				<td><c:out value='${item.isOtcunitString}'/>&nbsp;</td>
				<td><c:out value='${item.isResendLicenseString}'/>&nbsp;</td>

			  </tr>

		  	  </c:forEach>
		  </tbody>
		</table>
